93ae8b3a86c55a2abb7f39cd27f5e0484ba8bf3b,tests/frontend/org/voltdb/regressionsuites/TestSubQueriesSuite.java,TestSubQueriesSuite,testWhereRowSubSelects,#,1228
Before Change
client.callProcedure("R2.insert", 7, 50, 2 , "2013-09-18 02:00:00.123457");
VoltTable vt;
if (!isHSQL()) {
// R1 2, 10, 1 = R2 4, 10, 1
vt = client.callProcedure("@AdHoc",
"select R1.ID FROM R1 where (R1.WAGE, R1.DEPT) = (SELECT WAGE, DEPT FROM R2 where ID = 4);").getResults()[0];
After Change
public void testWhereRowSubSelects() throws NoConnectionsException, IOException, ProcCallException
{
if (isHSQL()) {
// hsqldb has back end error for these cases
return;
}
Client client = getClient();
client.callProcedure("R1.insert", 1, 5, 1 , "2013-06-18 02:00:00.123457");